package com.furniture.sql.manage;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * Created by Bob on 2016/3/23.
 */
public class NotesDB extends SQLiteOpenHelper {

    public static final String TABLE_NAME_NOTES = "notes";
    public static final String TABLE_NAME_MEDIA = "media";
    public static final String COLUMN_NAME_ID = "_id";
    public static final String COLUMN_NAME_NOTE_NAME = "name";
    public static final String COLUMN_NAME_NOTE_CONTENT = "content";
    public static final String COLUMN_NAME_NOTE_DATE = "date";
    public static final String COLUMN_NAME_MEDIA_PATH = "path";
    public static final String COLUMN_NAME_MEDIA_USER_PIC = "user_pic";
    public static final String COLUMN_NAME_MEDIA_GOOD_PIC = "good_pic";
    public static final String COLUMN_NAME_MEDIA_OWNER_NOTE_ID = "note_id";

    public NotesDB(Context context) {
        super(context, "notes", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table " + TABLE_NAME_NOTES + "(" +
                COLUMN_NAME_ID + " integer primary key autoincrement," +
                COLUMN_NAME_NOTE_NAME + " text not null default \"\"," +
                COLUMN_NAME_MEDIA_USER_PIC + "BLOB not null default\"\" ," + // 3: userPic
                COLUMN_NAME_MEDIA_GOOD_PIC + "BLOB not null default\"\" ," + // 4: goodPic
                COLUMN_NAME_NOTE_CONTENT + " text not null default \"\"," +
                COLUMN_NAME_NOTE_DATE + " text not null default \"\"" +
                ")");

        db.execSQL("create table " + TABLE_NAME_MEDIA + "(" +
                COLUMN_NAME_ID + " integer primary key autoincrement," +
                COLUMN_NAME_MEDIA_PATH + " text not null default \"\"," +
                COLUMN_NAME_MEDIA_OWNER_NOTE_ID + " integer not null default 0" +
                ")");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}
